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 1139: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;

1135: P_REF_25 VARCHAR2 DEFAULT NULL ,-- added by sriram - bug # 2769440
1136: P_REF_26 VARCHAR2 DEFAULT NULL -- added by sriram - bug # 2769440
1137: )
1138: IS
1139: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1140: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
1141: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1142: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1143: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;

Line 1140: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;

1136: P_REF_26 VARCHAR2 DEFAULT NULL -- added by sriram - bug # 2769440
1137: )
1138: IS
1139: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1140: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
1141: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1142: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1143: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1144: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

Line 1147: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

1143: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1144: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1145: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1146: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1147: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1148: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

Line 1148: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

1144: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1145: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1146: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1147: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1148: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

Line 1161: FROM wsh_delivery_details

1157:
1158: -- get the delivery details
1159: CURSOR c_get_delivery_details IS
1160: SELECT source_header_id, source_line_id
1161: FROM wsh_delivery_details
1162: WHERE delivery_detail_id = p_delivery_detail_id;
1163:
1164: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
1165: -- this also gets other details to link to requisition side and the from org id.

Line 3491: FROM wsh_delivery_details

3487: */
3488: -- get the delivery details
3489: CURSOR c_get_delivery_details IS
3490: SELECT source_header_id, source_line_id
3491: FROM wsh_delivery_details
3492: WHERE delivery_detail_id = p_reference_line_id;
3493:
3494: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
3495: -- this also gets other details to link to requisition side and the from org id.

Line 3561: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;

3557: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3558: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3559: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3560: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3561: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3562: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3563: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3564: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3565: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;

Line 3562: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;

3558: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3559: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3560: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3561: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3562: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3563: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3564: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3565: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3566: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

Line 3569: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

3565: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3566: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3567: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3568: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3569: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3570: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

Line 3570: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

3566: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3567: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3568: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3569: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3570: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;