在关闭Inventory 会计期时pengding的数据对应的SQL:

在关闭Inventory 会计期时pengding的数据对应的SQL:

A. Resolution Required
e#dWYE(q"E01 Unprocessed Material
"b8~P;XBB9F.V(q0SELECT COUNT(*)ITPUB个人空间2pT{#ur5^
FROM MTL_MATERIAL_TRANSACTIONS_TEMPITPUB个人空间,i%p$r2U6MG[
WHERE ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate' AND NVL(TRANSACTION_STATUS,0) <> 2;

2 Uncosted Material
V ZrES!Q!t
?G2U0SELECT COUNT(*)ITPUB个人空间*Gnt1a5a"t.V"u'p
FROM MTL_MATERIAL_TRANSACTIONSITPUB个人空间 `6a M:^g
WHERE ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate' AND COSTED_FLAG IS NOT NULL;

3 Pending WIP TransactionsITPUB个人空间(cz0G/r dc@`
SELECT COUNT(*) FROM WIP_COST_TXN_INTERFACE WHERE ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate';

4 Uncosted WSMITPUB个人空间WC$BRhUR
SELECT COUNT(*)
.N!dF5Z!aQ.L0FROM WSM_SPLIT_MERGE_TRANSACTIONSITPUB个人空间)E2Z!P)c#R-| l:l0\(L
WHERE ORGANIZATION_ID = &OrgID AND COSTED <> 4 AND TRANSACTION_DATE <= '&EndPeriodDate';

5 Pending WMS InterfaceITPUB个人空间 ~a)V IG3O9P a
SELECT COUNT(*)ITPUB个人空间9~G(U]G*pB/].V
FROM WSM_SPLIT_MERGE_TXN_INTERFACE
#~tp0SE0WHERE ORGANIZATION_ID = &OrgID AND PROCESS_STATUS <> 4 AND TRANSACTION_DATE <= '&EndPeriodDate';

ITPUB个人空间i$Bx@I W*w3d
B. Resolution RecommendedITPUB个人空间6C8l,gR9}WF!H YU
6 Pending Receiving
g,q:j v9vC)n1Uk0SELECT COUNT(*)ITPUB个人空间(S5a7R.R%w rdE
FROM RCV_TRANSACTIONS_INTERFACEITPUB个人空间uzbj*L9w
WHERE TO_ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate' AND DESTINATION_TYPE_CODE = 'INVENTORY';

7 Pending MaterialITPUB个人空间uU
q"R'b7Q)Fk
SELECT COUNT(*)
y5FLPX;{/c?0FROM MTL_TRANSACTIONS_INTERFACE
-r'}5D zG6\%|-Tx0WHERE ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate' AND PROCESS_FLAG <> 9;

8 Pending Shop Floor Move
Tka}"~ g0SELECT COUNT(*) FROM WIP_MOVE_TXN_INTERFACE WHERE ORGANIZATION_ID = &OrgID AND TRANSACTION_DATE <= '&EndPeriodDate';

C. Resolution Required / RecommendedITPUB个人空间n^7bQ7^!G
9 Unprocessed Shipping Transactions (Pending Transactions)
z X!T5wo*N6y0SELECT COUNT(*)ITPUB个人空间0{
P2R2B[_;o
FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, WSH_NEW_DELIVERIES WND,ITPUB个人空间?*WZ%fg2d e0S1H#ed0d
WSH_DELIVERY_LEGS WDL, WSH_TRIP_STOPS WTS
O
`1k:qD6r&Rx0WHERE WDD.SOURCE_CODE = 'OE' AND WDD.RELEASED_STATUS = 'C'
C%M3{o6lY(J0AND WDD.INV_INTERFACED_FLAG IN ('N' ,'P') AND WDD.ORGANIZATION_ID = &OrgID
"_y)e[9o[V']0AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WND.DELIVERY_ID = WDA.DELIVERY_IDITPUB个人空间@Z$U#p i"m
AND WND.STATUS_CODE IN ('CL','IT') AND WDL.DELIVERY_ID = WND.DELIVERY_ID
8K"EF4igh/Z
wPr3u0AND WTS.PENDING_INTERFACE_FLAG = 'Y' AND TRUNC(WTS.ACTUAL_DEPARTURE_DATE) BETWEEN '&StartPeriodDate' AND '&EndPeriodDate'ITPUB个人空间0E#gkwNvotJ!Y
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID;