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.

[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on JMF_SHIKYU_SPR_RPT_TEMP

Line 92: l_subcontract_po_shipment_id jmf_shikyu_spr_rpt_temp.SUBCONTRACT_PO_SHIPMENT_ID%TYPE ;

88: )
89: IS
90: l_api_name CONSTANT VARCHAR2(30) := 'spr_load_subcontracting_po';
91:
92: l_subcontract_po_shipment_id jmf_shikyu_spr_rpt_temp.SUBCONTRACT_PO_SHIPMENT_ID%TYPE ;
93: l_shipment_type jmf_shikyu_spr_rpt_temp.shipment_type%TYPE;
94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;
95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;

Line 93: l_shipment_type jmf_shikyu_spr_rpt_temp.shipment_type%TYPE;

89: IS
90: l_api_name CONSTANT VARCHAR2(30) := 'spr_load_subcontracting_po';
91:
92: l_subcontract_po_shipment_id jmf_shikyu_spr_rpt_temp.SUBCONTRACT_PO_SHIPMENT_ID%TYPE ;
93: l_shipment_type jmf_shikyu_spr_rpt_temp.shipment_type%TYPE;
94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;
95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;

Line 94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;

90: l_api_name CONSTANT VARCHAR2(30) := 'spr_load_subcontracting_po';
91:
92: l_subcontract_po_shipment_id jmf_shikyu_spr_rpt_temp.SUBCONTRACT_PO_SHIPMENT_ID%TYPE ;
93: l_shipment_type jmf_shikyu_spr_rpt_temp.shipment_type%TYPE;
94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;
95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;

Line 95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;

91:
92: l_subcontract_po_shipment_id jmf_shikyu_spr_rpt_temp.SUBCONTRACT_PO_SHIPMENT_ID%TYPE ;
93: l_shipment_type jmf_shikyu_spr_rpt_temp.shipment_type%TYPE;
94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;
95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;

Line 96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;

92: l_subcontract_po_shipment_id jmf_shikyu_spr_rpt_temp.SUBCONTRACT_PO_SHIPMENT_ID%TYPE ;
93: l_shipment_type jmf_shikyu_spr_rpt_temp.shipment_type%TYPE;
94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;
95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;

Line 97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;

93: l_shipment_type jmf_shikyu_spr_rpt_temp.shipment_type%TYPE;
94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;
95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;

Line 98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;

94: l_report_title_num jmf_shikyu_spr_rpt_temp.report_title_num%TYPE ;
95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;

Line 99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;

95: l_po_number jmf_shikyu_spr_rpt_temp.sub_po_num%TYPE ;
96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;

Line 100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;

96: l_agent_name jmf_shikyu_spr_rpt_temp.agent_name%TYPE ;
97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;

Line 101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;

97: l_line_num jmf_shikyu_spr_rpt_temp.SUB_PO_LINE_NUM%TYPE ;
98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;

Line 102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;

98: l_shipment_num jmf_shikyu_spr_rpt_temp.SHIP_OR_RELEASE_NUM%TYPE ;
99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;

Line 103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;

99: l_revision_num jmf_shikyu_spr_rpt_temp.REV_NUM%TYPE ;
100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;

Line 104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;

100: l_creation_date jmf_shikyu_spr_rpt_temp.CREATION_DATE%TYPE ;
101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;

Line 105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;

101: l_created_by_name jmf_shikyu_spr_rpt_temp.CREATED_BY_NAME%TYPE ;
102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;

Line 106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;

102: l_revised_date jmf_shikyu_spr_rpt_temp.REVISED_DATE%TYPE ;
103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;

Line 107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;

103: l_last_updated_by_name jmf_shikyu_spr_rpt_temp.REVISED_BY_NAME%TYPE ;
104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;

Line 108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;

104: l_vendor_site_code jmf_shikyu_spr_rpt_temp.VENDOR_SITE_CODE%TYPE ;
105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;

Line 109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;

105: l_vendor_address_line1 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS1%TYPE ;
106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;
113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;

Line 110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;

106: l_vendor_address_line2 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS2%TYPE ;
107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;
113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;
114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;

Line 111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;

107: l_vendor_address_line3 jmf_shikyu_spr_rpt_temp.VENDOR_SITE_ADDRESS3%TYPE ;
108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;
113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;
114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;
115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;

Line 112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;

108: l_shipto_location_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_CODE%TYPE ;
109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;
113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;
114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;
115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;
116:

Line 113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;

109: l_shipto_address_line_1 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS1%TYPE ;
110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;
113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;
114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;
115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;
116:
117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;

Line 114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;

110: l_shipto_address_line_2 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS2%TYPE ;
111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;
113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;
114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;
115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;
116:
117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;
118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;

Line 115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;

111: l_shipto_address_line_3 jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_ADDRESS3%TYPE ;
112: l_billto_location_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_CODE%TYPE ;
113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;
114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;
115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;
116:
117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;
118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;
119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;

Line 117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;

113: l_billto_address_line_1 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS1%TYPE ;
114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;
115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;
116:
117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;
118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;
119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;
120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;
121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;

Line 118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;

114: l_billto_address_line_2 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS2%TYPE ;
115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;
116:
117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;
118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;
119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;
120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;
121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;
122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;

Line 119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;

115: l_billto_address_line_3 jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_ADDRESS3%TYPE ;
116:
117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;
118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;
119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;
120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;
121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;
122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;
123:

Line 120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;

116:
117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;
118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;
119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;
120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;
121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;
122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;
123:
124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;

Line 121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;

117: l_vendor_city_state_zip jmf_shikyu_spr_rpt_temp.VENDOR_CITY_STATE_ZIP%TYPE ;
118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;
119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;
120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;
121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;
122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;
123:
124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;
125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;

Line 122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;

118: l_vendor_country jmf_shikyu_spr_rpt_temp.VENDOR_COUNTRY%TYPE ;
119: l_ship_to_site_postal_code jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_POSTAL_CODE%TYPE ;
120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;
121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;
122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;
123:
124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;
125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;
126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;

Line 124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;

120: l_ship_to_site_country jmf_shikyu_spr_rpt_temp.SHIP_TO_SITE_COUNTRY%TYPE ;
121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;
122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;
123:
124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;
125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;
126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;
127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;

Line 125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;

121: l_billto_site_postal_code jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_POSTAL_CODE%TYPE ;
122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;
123:
124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;
125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;
126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;
127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;

Line 126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;

122: l_billto_site_country jmf_shikyu_spr_rpt_temp.BILL_TO_SITE_COUNTRY%TYPE ;
123:
124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;
125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;
126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;
127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;

Line 127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;

123:
124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;
125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;
126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;
127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;

Line 128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;

124: l_customer_num jmf_shikyu_spr_rpt_temp.CUSTOMER_NUM%TYPE ;
125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;
126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;
127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;

Line 129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;

125: l_supplier_num jmf_shikyu_spr_rpt_temp.SUPPLIER_NUM%TYPE ;
126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;
127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;

Line 130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;

126: l_pay_term jmf_shikyu_spr_rpt_temp.PAY_TERM%TYPE ;
127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;

Line 131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;

127: l_FREIGHT_TERM jmf_shikyu_spr_rpt_temp.FREIGHT_TERM%TYPE ;
128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;

Line 132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;

128: l_FOB_TYPE jmf_shikyu_spr_rpt_temp.FOB_TYPE%TYPE ;
129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;

Line 133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;

129: l_SHIPPING_CONTROL jmf_shikyu_spr_rpt_temp.SHIPPING_CONTROL%TYPE ;
130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;

Line 134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;

130: l_SHIP_VIA jmf_shikyu_spr_rpt_temp.SHIP_VIA%TYPE ;
131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;

Line 135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;

131: l_CONFIRM_TO_NAME jmf_shikyu_spr_rpt_temp.CONFIRM_TO_NAME%TYPE ;
132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;

Line 136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;

132: l_CONFIRM_TO_TELEPHONE jmf_shikyu_spr_rpt_temp.CONFIRM_TO_TELEPHONE%TYPE ;
133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;

Line 137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;

133: l_REQUESTER jmf_shikyu_spr_rpt_temp.REQUESTER%TYPE ;
134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;

Line 138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;

134: l_NOTES jmf_shikyu_spr_rpt_temp.NOTES%TYPE ;
135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;

Line 139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;

135: l_project_num jmf_shikyu_spr_rpt_temp.PROJECT_NUM%TYPE ;
136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;

Line 140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;

136: l_task_num jmf_shikyu_spr_rpt_temp.TASK_NUM%TYPE ;
137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;

Line 141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;

137: l_ITEM_NUM jmf_shikyu_spr_rpt_temp.ITEM_NUM%TYPE ;
138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;

Line 142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;

138: l_ITEM_DESC jmf_shikyu_spr_rpt_temp.ITEM_DESC%TYPE ;
139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;
146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;

Line 143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;

139: l_NEED_BY_DATE jmf_shikyu_spr_rpt_temp.NEED_BY_DATE%TYPE ;
140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;
146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;
147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;

Line 144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;

140: l_PROMISED_DATE jmf_shikyu_spr_rpt_temp.PROMISED_DATE%TYPE ;
141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;
146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;
147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;
148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;

Line 145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;

141: l_QUANTITY jmf_shikyu_spr_rpt_temp.QUANTITY%TYPE ;
142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;
146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;
147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;
148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;
149:

Line 146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;

142: l_UOM jmf_shikyu_spr_rpt_temp.UOM%TYPE ;
143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;
146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;
147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;
148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;
149:
150: l_print_count po_headers_all.print_count%TYPE;

Line 147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;

143: l_ITEM_PRICE jmf_shikyu_spr_rpt_temp.ITEM_PRICE%TYPE ;
144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;
146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;
147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;
148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;
149:
150: l_print_count po_headers_all.print_count%TYPE;
151: l_printed_date po_headers_all.printed_date%TYPE;

Line 148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;

144: l_TAXABLE_FLAG jmf_shikyu_spr_rpt_temp.TAXABLE_FLAG%TYPE ;
145: l_AMOUNT jmf_shikyu_spr_rpt_temp.AMOUNT%TYPE ;
146: l_AGENT_ID jmf_shikyu_spr_rpt_temp.AGENT_ID%TYPE ;
147: l_VENDOR_ID jmf_shikyu_spr_rpt_temp.VENDOR_ID%TYPE ;
148: l_ITEM_ID jmf_shikyu_spr_rpt_temp.ITEM_ID%TYPE ;
149:
150: l_print_count po_headers_all.print_count%TYPE;
151: l_printed_date po_headers_all.printed_date%TYPE;
152: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 372: DELETE FROM jmf_shikyu_spr_rpt_temp;

368: ,g_module_prefix || l_api_name || '.begin'
369: ,NULL);
370: END IF;
371:
372: DELETE FROM jmf_shikyu_spr_rpt_temp;
373:
374: commit;
375:
376: SELECT psp.manual_po_num_type manual_po_num_type

Line 497: INSERT INTO jmf_shikyu_spr_rpt_temp

493: CLOSE l_cur_get_blanket_po;
494:
495: END IF;
496:
497: INSERT INTO jmf_shikyu_spr_rpt_temp
498: ( subcontract_po_shipment_id
499: , shipment_type
500: , report_title_num
501: , sub_po_num