[Home] [Help]
91: l_stmt_num NUMBER;
92:
93: CURSOR inception_date_cursor IS
94: SELECT o.orgn_code co_code, log.transaction_date inception_date
95: FROM opi_dbi_inv_value_log log, sy_orgn_mst o
96: WHERE log.type= 'OID'
97: AND o.organization_id = log.organization_id
98: AND g_global_start_date > log.transaction_date;
99:
135: g_user_id created_by,
136: g_user_id last_updated_by,
137: g_login_id last_update_login
138: FROM
139: sy_orgn_mst c,
140: gl_subr_led led
141: WHERE
142: c.orgn_code = led.co_code
143: GROUP BY c.organization_id;
226: UNION ALL
227: SELECT t.item_id, t.whse_code, -t.trans_qty
228: FROM
229: opi_dbi_inv_value_log sd,
230: sy_orgn_mst o,
231: ic_tran_pnd t
232: WHERE
233: sd.type = 'OID'
234: AND o.organization_id = sd.organization_id
238: UNION ALL
239: SELECT t.item_id, t.whse_code, -t.trans_qty
240: FROM
241: opi_dbi_inv_value_log sd,
242: sy_orgn_mst o,
243: ic_tran_cmp t
244: WHERE
245: sd.type = 'OID'
246: AND o.organization_id = sd.organization_id
280: FROM
281: opi_dbi_opm_inception_qty q,
282: opi_dbi_inv_value_log id,
283: ic_whse_mst w,
284: sy_orgn_mst o,
285: sy_orgn_mst c
286: WHERE
287: w.whse_code = q.whse_code
288: AND o.orgn_code = w.orgn_code
281: opi_dbi_opm_inception_qty q,
282: opi_dbi_inv_value_log id,
283: ic_whse_mst w,
284: sy_orgn_mst o,
285: sy_orgn_mst c
286: WHERE
287: w.whse_code = q.whse_code
288: AND o.orgn_code = w.orgn_code
289: AND c.orgn_code = o.co_code
454: (-1 * pnd.trans_qty) qty
455: FROM
456: ic_tran_pnd pnd,
457: ic_xfer_mst xfer,
458: sy_orgn_mst o,
459: opi_dbi_inv_value_log sd
460: WHERE
461: pnd.doc_id = xfer.transfer_id
462: AND xfer.transfer_status = 2 -- not received yet
497: mtl_system_items_b msi,
498: ic_whse_mst whse_mst,
499: ic_item_mst_b ic_item,
500: mtl_interorg_parameters mip,
501: sy_orgn_mst o,
502: sy_orgn_mst c,
503: opi_dbi_inv_value_log sd
504: WHERE supply_type_code in ('SHIPMENT' , 'RECEIVING')
505: AND intransit_owning_org_id is not NULL -- necessary for
498: ic_whse_mst whse_mst,
499: ic_item_mst_b ic_item,
500: mtl_interorg_parameters mip,
501: sy_orgn_mst o,
502: sy_orgn_mst c,
503: opi_dbi_inv_value_log sd
504: WHERE supply_type_code in ('SHIPMENT' , 'RECEIVING')
505: AND intransit_owning_org_id is not NULL -- necessary for
506: -- intransit
553: (-1 * pnd.trans_qty) qty
554: FROM
555: ic_tran_vw1 pnd,
556: ic_xfer_mst xfer,
557: sy_orgn_mst o,
558: opi_dbi_inv_value_log sd
559: WHERE pnd.completed_ind = 1 -- completed transfer
560: -- view sets completed_ind to 1
561: -- for everything in the ic_tran_cmp
608: ic_whse_mst whse_mst,
609: mtl_system_items_b msi,
610: ic_item_mst_b ic_item,
611: mtl_interorg_parameters mip,
612: sy_orgn_mst o,
613: opi_dbi_inv_value_log sd
614: WHERE ic_tran.completed_ind = 1 -- but complete
615: AND ic_tran.doc_type = 'OMSO' -- internal sales order shipment
616: AND ic_tran.line_id = oola.line_id -- get line id details
664: ic_whse_mst whse_mst,
665: mtl_system_items_b msi,
666: ic_item_mst_b ic_item,
667: mtl_interorg_parameters mip,
668: sy_orgn_mst o,
669: opi_dbi_inv_value_log sd
670: WHERE ic_tran.completed_ind = 1 -- but complete
671: AND ic_tran.doc_type = 'PORC' -- internal sales order shipment
672: AND rcv.transaction_id = ic_tran.line_id
750: from
751: gl_subr_led l,
752: gme_batch_header h,
753: ic_whse_mst w,
754: sy_orgn_mst o,
755: opi_dbi_inv_value_log log
756: where
757: l.doc_type = 'PROD'
758: and l.acct_ttl_type = 1530
775: HAVING
776: nvl(sum(led.amount_base * gmd.cost_alloc),0) <> 0
777: ) ib,
778: ic_whse_mst w,
779: sy_orgn_mst o,
780: sy_orgn_mst c,
781: ic_item_mst_b i,
782: mtl_system_items_b msi,
783: opi_dbi_inv_value_log log
776: nvl(sum(led.amount_base * gmd.cost_alloc),0) <> 0
777: ) ib,
778: ic_whse_mst w,
779: sy_orgn_mst o,
780: sy_orgn_mst c,
781: ic_item_mst_b i,
782: mtl_system_items_b msi,
783: opi_dbi_inv_value_log log
784: WHERE