[Home] [Help]
128: DISTINCT
129: MP.ORGANIZATION_CODE || ' ' || R.RECEIPT_NUM
130: FROM
131: RCV_SHIPMENT_HEADERS R,
132: MTL_MATERIAL_TRANSACTIONS P,
133: MTL_PARAMETERS MP
134: WHERE R.SHIPMENT_HEADER_ID = P.TRANSACTION_SOURCE_ID
135: AND R.ORGANIZATION_ID = P.ORGANIZATION_ID
136: AND P.TRANSACTION_SOURCE_ID = DOC_ID
149: CURSOR CUR_GET_CYCL IS
150: SELECT
151: MP.ORGANIZATION_CODE || ' ' || MCC.COUNT_LIST_SEQUENCE
152: FROM
153: MTL_MATERIAL_TRANSACTIONS MTT,
154: MTL_PARAMETERS MP,
155: MTL_CYCLE_COUNT_ENTRIES MCC
156: WHERE MTT.CYCLE_COUNT_ID = DOC_ID
157: AND MP.ORGANIZATION_ID = MTT.ORGANIZATION_ID
159: CURSOR CUR_GET_XFER IS
160: SELECT
161: MP.ORGANIZATION_CODE
162: FROM
163: MTL_MATERIAL_TRANSACTIONS MMT,
164: MTL_PARAMETERS MP
165: WHERE MMT.TRANSFER_TRANSACTION_ID = DOC_ID
166: AND MP.ORGANIZATION_ID = MMT.ORGANIZATION_ID;
167: CURSOR C_SO_DOC(P_DOC_ID IN NUMBER,P_LEGAL_ENTITY_ID IN NUMBER,P_LINE_ID IN NUMBER) IS
169: DISTINCT
170: MP.ORGANIZATION_CODE || ' ' || D.NAME
171: FROM
172: WSH_NEW_DELIVERIES D,
173: MTL_MATERIAL_TRANSACTIONS T,
174: WSH_DELIVERY_DETAILS WD,
175: WSH_DELIVERY_ASSIGNMENTS WA,
176: MTL_PARAMETERS MP,
177: MTL_TXN_SOURCE_TYPES MTST,
190: DISTINCT
191: '(Bill-Only) ' || MP.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
192: FROM
193: MTL_PARAMETERS MP,
194: MTL_MATERIAL_TRANSACTIONS T,
195: OE_ORDER_HEADERS_ALL OH,
196: OE_ORDER_LINES_ALL OL,
197: MTL_TXN_SOURCE_TYPES MTST,
198: ORG_ORGANIZATION_DEFINITIONS OOD
208: SELECT
209: DISTINCT
210: '(Drop-Ship) ' || OOD.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
211: FROM
212: MTL_MATERIAL_TRANSACTIONS T,
213: OE_ORDER_HEADERS_ALL OH,
214: OE_ORDER_LINES_ALL OL,
215: MTL_TXN_SOURCE_TYPES MTST,
216: ORG_ORGANIZATION_DEFINITIONS OOD