[Home] [Help]
57: , poh.note_to_receiver
58: , to_char(poh.org_id) --
59: FROM rcv_supply ms
60: , rcv_transactions rt
61: , po_headers_all poh
62: , po_lines_all pol
63: , po_line_types plt
64: , mtl_parameters mp
65: WHERE poh.po_header_id = ms.po_header_id
970: WHERE msik.inventory_item_id = rsl.item_id
971: AND msik.organization_id = p_organization_id
972: AND msik.mtl_transactions_enabled_flag = 'N')
973: OR exists
974: (select '1' from po_headers_all poh
975: , po_lines_all pol
976: , po_line_types plt
977: where rt.po_header_id is not null
978: and rt.po_header_id = poh.po_header_id
1143: WHERE msik.inventory_item_id = rsl.item_id
1144: AND msik.organization_id = p_organization_id
1145: AND msik.mtl_transactions_enabled_flag = 'N')
1146: OR exists (select '1'
1147: from po_headers_all poh
1148: , po_lines_all pol
1149: , po_line_types plt
1150: where rt.po_header_id is not null
1151: and rt.po_header_id = poh.po_header_id
3113: , woov.department_code
3114: , pda.po_distribution_id
3115: , (pda.quantity_ordered - pda.quantity_delivered)
3116: , woov.repetitive_schedule_id
3117: FROM po_headers_all phl
3118: , po_lines_all pla
3119: , po_distributions_all pda
3120: , po_releases_all prl
3121: , wip_osp_jobs_val_v wojv
3153: , woov.department_code
3154: , pda.po_distribution_id
3155: , (pda.quantity_ordered - pda.quantity_delivered)
3156: , woov.repetitive_schedule_id
3157: FROM po_headers_all phl
3158: , po_lines_all pla
3159: , po_distributions_all pda
3160: , wip_osp_jobs_val_v wojv
3161: , wip_osp_lines_val_v wolv
3191: , woov.department_code
3192: , pda.po_distribution_id
3193: , (pda.quantity_ordered - pda.quantity_delivered)
3194: , woov.repetitive_schedule_id
3195: FROM po_headers_all phl
3196: , po_lines_all pla
3197: , po_distributions_all pda
3198: , wip_osp_jobs_val_v wojv
3199: , wip_osp_lines_val_v wolv