eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 66: requisition_number po_requisition_headers_all.segment1%type,

62: ro_qty csd_repairs.quantity%type,
63: ro_rcvd_qty csd_repairs.quantity_rcvd%type,
64: inventory_item_id csd_repairs.inventory_item_id%type,
65: ro_uom csd_repairs.unit_of_measure%type,
66: requisition_number po_requisition_headers_all.segment1%type,
67: ordered_quantity oe_order_lines_all.ordered_quantity%type,
68: order_number oe_order_headers_all.order_number%type
69: );
70:

Line 128: requisition_number po_requisition_headers_all.segment1%type ,

124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,
128: requisition_number po_requisition_headers_all.segment1%type ,
129: source_org_name hr_all_organization_units.name%type ,
130: destination_org_name hr_all_organization_units.name%type ,
131: txn_source_id mtl_txn_request_lines.txn_source_id%type
132: );

Line 3306: po_requisition_headers_all prh,

3302: oel.ordered_quantity,
3303: oeh.order_number
3304: from csd_product_transactions cpt,
3305: csd_repairs cra,
3306: po_requisition_headers_all prh,
3307: oe_order_lines_all oel,
3308: oe_order_headers_all oeh
3309: where cpt.repair_line_id = cra.repair_line_id
3310: AND cpt.req_header_id = prh.requisition_header_id

Line 3342: po_requisition_headers_all prh,

3338: oel.ordered_quantity,
3339: oeh.order_number
3340: from csd_product_transactions cpt,
3341: csd_repairs cra,
3342: po_requisition_headers_all prh,
3343: oe_order_lines_all oel,
3344: oe_order_headers_all oeh
3345: where cpt.repair_line_id = cra.repair_line_id
3346: AND cpt.req_header_id = prh.requisition_header_id

Line 3383: po_requisition_headers_all prh,

3379: mtl.lot_control_code,
3380: hao.name org_name
3381: from rcv_transactions rcv,
3382: po_requisition_lines_all prl,
3383: po_requisition_headers_all prh,
3384: mtl_system_items mtl,
3385: hr_all_organization_units hao
3386: where rcv.requisition_line_id = prl.requisition_line_id
3387: and prl.item_id = mtl.inventory_item_id

Line 3454: po_requisition_headers_all prh

3450: BEGIN
3451: select 'EXISTS'
3452: into l_dummy
3453: from oe_order_headers_all oeh,
3454: po_requisition_headers_all prh
3455: where oeh.source_document_id = prh.requisition_header_id
3456: and oeh.header_id = p_order_header_id
3457: and exists (select 'x'
3458: from csd_product_transactions cpt

Line 4720: po_requisition_headers_all prh,

4716: oel.ordered_quantity,
4717: oeh.order_number
4718: from csd_product_transactions cpt,
4719: csd_repairs cra,
4720: po_requisition_headers_all prh,
4721: oe_order_lines_all oel,
4722: oe_order_headers_all oeh
4723: where cpt.repair_line_id = cra.repair_line_id
4724: AND cpt.req_header_id = prh.requisition_header_id

Line 4756: po_requisition_headers_all prh,

4752: oel.ordered_quantity,
4753: oeh.order_number
4754: from csd_product_transactions cpt,
4755: csd_repairs cra,
4756: po_requisition_headers_all prh,
4757: oe_order_lines_all oel,
4758: oe_order_headers_all oeh
4759: where cpt.repair_line_id = cra.repair_line_id
4760: AND cpt.req_header_id = prh.requisition_header_id

Line 4799: po_requisition_headers_all prh,

4795: mtl.lot_control_code,
4796: hao.name org_name
4797: from rcv_transactions rcv,
4798: po_requisition_lines_all prl,
4799: po_requisition_headers_all prh,
4800: mtl_system_items mtl,
4801: hr_all_organization_units hao
4802: where rcv.requisition_line_id = prl.requisition_line_id
4803: and prl.item_id = mtl.inventory_item_id

Line 4870: po_requisition_headers_all prh

4866: BEGIN
4867: select 'EXISTS'
4868: into l_dummy
4869: from oe_order_headers_all oeh,
4870: po_requisition_headers_all prh
4871: where oeh.source_document_id = prh.requisition_header_id
4872: and oeh.header_id = p_order_header_id
4873: and exists (select 'x'
4874: from csd_product_transactions cpt

Line 7332: po_requisition_headers_all prh,

7328: from oe_order_lines_all oel,
7329: wsh_delivery_details dd,
7330: wsh_serial_numbers dsn,--Added to fix 3801614
7331: po_requisition_lines_all prl,
7332: po_requisition_headers_all prh,
7333: mtl_system_items mtl,
7334: hr_all_organization_units hao,
7335: hr_all_organization_units hao1,
7336: mtl_txn_request_lines trl

Line 7389: po_requisition_headers_all prh,

7385: from oe_order_lines_all oel,
7386: wsh_delivery_details dd,
7387: wsh_serial_numbers dsn,--Added to fix 3801614
7388: po_requisition_lines_all prl,
7389: po_requisition_headers_all prh,
7390: mtl_system_items mtl,
7391: hr_all_organization_units hao,
7392: hr_all_organization_units hao1,
7393: mtl_txn_request_lines trl

Line 7525: po_requisition_headers_all prh

7521: BEGIN
7522: select 'EXISTS'
7523: into l_dummy
7524: from oe_order_headers_all oeh,
7525: po_requisition_headers_all prh
7526: where oeh.source_document_id = prh.requisition_header_id
7527: and oeh.header_id = p_order_header_id
7528: and exists (select 'x'
7529: from csd_product_transactions cpt