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.JAI_OM_RG_PKG dependencies on WSH_DELIVERY_DETAILS

Line 1185: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;

1181: P_REF_25 VARCHAR2 DEFAULT NULL ,-- added by sriram - bug # 2769440
1182: P_REF_26 VARCHAR2 DEFAULT NULL -- added by sriram - bug # 2769440
1183: )
1184: IS
1185: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1186: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
1187: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1188: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1189: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;

Line 1186: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;

1182: P_REF_26 VARCHAR2 DEFAULT NULL -- added by sriram - bug # 2769440
1183: )
1184: IS
1185: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1186: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
1187: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1188: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1189: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

Line 1193: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

1189: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1192: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1193: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1196: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1197: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

Line 1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1192: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1193: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1196: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1197: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1198: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

Line 1207: FROM wsh_delivery_details

1203:
1204: -- get the delivery details
1205: CURSOR c_get_delivery_details IS
1206: SELECT source_header_id, source_line_id
1207: FROM wsh_delivery_details
1208: WHERE delivery_detail_id = p_delivery_detail_id;
1209:
1210: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
1211: -- this also gets other details to link to requisition side and the from org id.

Line 3789: FROM wsh_delivery_details

3785: */
3786: -- get the delivery details
3787: CURSOR c_get_delivery_details IS
3788: SELECT source_header_id, source_line_id
3789: FROM wsh_delivery_details
3790: WHERE delivery_detail_id = p_reference_line_id;
3791:
3792: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
3793: -- this also gets other details to link to requisition side and the from org id.

Line 3860: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;

3856: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3859: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3860: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3863: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3864: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;

Line 3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;

3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3859: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3860: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3863: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3864: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

Line 3868: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

3864: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3867: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3868: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3871: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3872: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

Line 3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3867: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3868: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3871: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3872: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3873: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;